﻿
CREATE PROCEDURE [dbo].[ProcessStatistic]
(
	@Note varchar(250) OUTPUT,
	@ModifyDateTime datetime OUTPUT,
	@ModifyWhom varchar(50) OUTPUT
)
AS

SET @ModifyDateTime = getdate() 

IF @ModifyWhom is Null SET @ModifyWhom = SYSTEM_USER
ELSE SET @ModifyWhom = Left(@ModifyWhom  + ' : ' + SYSTEM_USER, 50)

IF rtrim(@Note) = '' SET @Note = Null

RETURN 0



